package com.bw.gmall.mapper;

import com.bw.gmall.domain.KeyWord;
import com.bw.gmall.domain.Pro;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

// 一个只能对应数据库的一张表
@Mapper
public interface KeyWordMapper {
    @Select("select keyword name,sum(keyword_count) value from dws_traffic_source_keyword_page_view_window where cur_date=#{date} group by keyword")
    List<KeyWord> queryKeyWord(Integer date);

}
